Round 1 - Technical

🔹 Introduction

🔹 Interviewer asked me about my past experience and background

🔹 Given two tables, perform Inner Join on column A & B and print total row count of output (Hint: Null Safe Join)

Table-1  Table-2

--------    --------

| A  |    | B  |

|------|    |------|

| 1  |    | 2  |

| 2  |    | 3  |

| 3  |    | 4  |

| 3  |    | 3  |

| NULL |  | NULL |

| 5  |    | 5  |

| 7  |    | NULL |

| NULL |  | 6  |

--------    --------

🔹 Interviewer gave one sample table schema for cricket scoreboard and asked adhoc SQL queries around that

🔹 DSA Question - Given a list of numbers, find all such pairs from the list whose sum is equal to the given value X

🔹 DSA Question - Find all the anagrams from the given list of strings

Round 2 - Technical

🔹 Question about my previous projects based on resume

🔹 Apache Spark related fundamental questions along with failure scenarios and job optimization

🔹 Interviewer gave me a dataset with 4-5 columns and a problem statement which I had to solve using PySpark and write code on paper for the same

🔹 DSA Question - Reverse a given linked list

Round 3 - Techno Managerial

🔹 Architecture discussion of the projects which I worked on previously

🔹 Behavioural Questions - If you had some project related conflict with a team mate then how did you resolve it?

🔹 Behavioural Questions - Have you ever missed the project delivery timelines? If it happened ever then how did you communicate it to the leadership and stakeholders?

🔹 Design discussion about a problem statement related to Online Ticket Booking System

Round 4 - HR Discussion

🔹 Salary discussion

🔹 Reason for switching job

🔹 What are you looking for in your next job

He received the offer letter after the final HR round..😊